/**
 * P6Spy
 *
 * Copyright (C) 2002 - 2020 P6Spy
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.swak.persistence.metrics.wrapper;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;

import com.swak.meters.MetricsFactory;
import com.swak.meters.SqlMetrics;

/**
 * This implementation wraps a {@link StatementWrapper} and notifies a
 * {@link JdbcEventListener} about certain method invocations.
 * <p>
 * This class implements the Wrapper or Decorator pattern. Methods default to
 * calling through to the wrapped request object.
 *
 * @see Statement
 */
public class StatementWrapper extends AbstractWrapper implements Statement {

	private final Statement delegate;

	public static Statement wrap(Statement delegate, MetricsFactory metricsFactory) {
		if (delegate == null) {
			return null;
		}
		return new StatementWrapper(delegate, metricsFactory);
	}

	protected StatementWrapper(Statement delegate, MetricsFactory metricsFactory) {
		super(delegate, metricsFactory);
		this.delegate = delegate;
	}

	@Override
	public ResultSet getResultSet() throws SQLException {
		return delegate.getResultSet();
	}

	@Override
	public ResultSet executeQuery(String sql) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		try {
			return delegate.executeQuery(sql);
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public int[] executeBatch() throws SQLException {
		return delegate.executeBatch();
	}

	@Override
	public boolean execute(String sql) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		try {
			return delegate.execute(sql);
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public boolean execute(String sql, int autoGeneratedKeys) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		try {
			return delegate.execute(sql, autoGeneratedKeys);
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public boolean execute(String sql, int[] columnIndexes) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		try {
			return delegate.execute(sql, columnIndexes);
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public boolean execute(String sql, String[] columnNames) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		try {
			return delegate.execute(sql, columnNames);
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public int executeUpdate(String sql) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		int rowCount = 0;
		try {
			rowCount = delegate.executeUpdate(sql);
			return rowCount;
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		int rowCount = 0;
		try {
			rowCount = delegate.executeUpdate(sql, autoGeneratedKeys);
			return rowCount;
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public int executeUpdate(String sql, int[] columnIndexes) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		int rowCount = 0;
		try {
			rowCount = delegate.executeUpdate(sql, columnIndexes);
			return rowCount;
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public int executeUpdate(String sql, String[] columnNames) throws SQLException {
		SQLException e = null;
		SqlMetrics<Object> metrics = this.beginMetrics(sql);
		Object context = metrics != null ? metrics.begin() : null;
		int rowCount = 0;
		try {
			rowCount = delegate.executeUpdate(sql, columnNames);
			return rowCount;
		} catch (SQLException sqle) {
			e = sqle;
			throw e;
		} finally {
			if (metrics != null) {
				metrics.end(context, e == null);
			}
		}
	}

	@Override
	public void addBatch(String sql) throws SQLException {
		delegate.addBatch(sql);
	}

	@Override
	public void close() throws SQLException {
		delegate.close();
	}

	@Override
	public int getMaxFieldSize() throws SQLException {
		return delegate.getMaxFieldSize();
	}

	@Override
	public void setMaxFieldSize(int max) throws SQLException {
		delegate.setMaxFieldSize(max);
	}

	@Override
	public int getMaxRows() throws SQLException {
		return delegate.getMaxRows();
	}

	@Override
	public void setMaxRows(int max) throws SQLException {
		delegate.setMaxRows(max);
	}

	@Override
	public void setEscapeProcessing(boolean enable) throws SQLException {
		delegate.setEscapeProcessing(enable);
	}

	@Override
	public int getQueryTimeout() throws SQLException {
		return delegate.getQueryTimeout();
	}

	@Override
	public void setQueryTimeout(int seconds) throws SQLException {
		delegate.setQueryTimeout(seconds);
	}

	@Override
	public void cancel() throws SQLException {
		delegate.cancel();
	}

	@Override
	public SQLWarning getWarnings() throws SQLException {
		return delegate.getWarnings();
	}

	@Override
	public void clearWarnings() throws SQLException {
		delegate.clearWarnings();
	}

	@Override
	public void setCursorName(String name) throws SQLException {
		delegate.setCursorName(name);
	}

	@Override
	public int getUpdateCount() throws SQLException {
		return delegate.getUpdateCount();
	}

	@Override
	public boolean getMoreResults() throws SQLException {
		return delegate.getMoreResults();
	}

	@Override
	public void setFetchDirection(int direction) throws SQLException {
		delegate.setFetchDirection(direction);
	}

	@Override
	public int getFetchDirection() throws SQLException {
		return delegate.getFetchDirection();
	}

	@Override
	public void setFetchSize(int rows) throws SQLException {
		delegate.setFetchSize(rows);
	}

	@Override
	public int getFetchSize() throws SQLException {
		return delegate.getFetchSize();
	}

	@Override
	public int getResultSetConcurrency() throws SQLException {
		return delegate.getResultSetConcurrency();
	}

	@Override
	public int getResultSetType() throws SQLException {
		return delegate.getResultSetType();
	}

	@Override
	public void clearBatch() throws SQLException {
		delegate.clearBatch();
	}

	@Override
	public Connection getConnection() throws SQLException {
		return delegate.getConnection();
	}

	@Override
	public boolean getMoreResults(int current) throws SQLException {
		return delegate.getMoreResults(current);
	}

	@Override
	public ResultSet getGeneratedKeys() throws SQLException {
		return delegate.getGeneratedKeys();
	}

	@Override
	public int getResultSetHoldability() throws SQLException {
		return delegate.getResultSetHoldability();
	}

	@Override
	public boolean isClosed() throws SQLException {
		return delegate.isClosed();
	}

	@Override
	public void setPoolable(boolean poolable) throws SQLException {
		delegate.setPoolable(poolable);
	}

	@Override
	public boolean isPoolable() throws SQLException {
		return delegate.isPoolable();
	}

	@Override
	public void closeOnCompletion() throws SQLException {
		delegate.closeOnCompletion();
	}

	@Override
	public boolean isCloseOnCompletion() throws SQLException {
		return delegate.isCloseOnCompletion();
	}

}
